Selecting from MySQL's "FULL PROCESSLIST"Edit

Starting with MySQL 5.1.7 you can do:

SELECT * FROM information_schema.PROCESSLIST;

You can apply a where clause or any other clause legal in a SELECT statement.